<?php
class SignRecords extends BaseBean{
    
    public $_table= "tb_sign_records";
    public $_primarykey= "id";
    protected $_table_alias= "a";
    public function __construct(){
        $this->addChild("SignPhotos","id","sign_id");
    }


    public function generateSql(){
        return "select a.*,b.mobile,b.name as user_name,c.name as shop  from tb_sign_records a 
            left join tb_users b on a.user_id=b.id
            left join tb_shop c on c.id = a.shop_id";
    }

    


  
}
?>